package com.xiaozhichao.javaapi.base.condition;

import org.junit.Test;

public class ConditionTest {

    @Test
    public void switchTest() {
        int i = 2;
        int result = 0;
        switch (i) {
            case 1:
                result = result + i;
            case 2:
                result = result + i * 2;
            case 3:
                result = result + i * 3;
        }
        System.out.println(result);
    }
}
// select 购物人 from 购物信息 group by 购物人 HAVING COUNT(*) > 1

// select 姓名 from 成绩表 group by 姓名 HAVING COUNT(*) > 1 and 分数>60
